Name | Type | Length | IsNullable | Collation |
ProductID | int | 4 | ||
ProductName | nvarchar | 80 | SQL_Latin1_General_CP1_CI_AS | |
ProductName | sysname | 80 | SQL_Latin1_General_CP1_CI_AS |
create view "Current Product List" AS
SELECT Product_List.ProductID, Product_List.ProductName
FROM Products AS Product_List
WHERE (((Product_List.Discontinued)=0))
--ORDER BY Product_List.ProductName